;
WITH t AS (SELECT * FROM seat_reserve se WHERE rsv_status = '0')
SELECT t1.line_id LINE
     , t1.seat_no SEAT_F
     , t3.seat_no SEAT_T
FROM t AS t1
     JOIN t AS t2 ON t1.line_id = t2.line_id AND t1.seat_no + 1 = t2.seat_no
     JOIN t AS t3 ON t2.line_id = t3.line_id AND t2.seat_no + 1 = t3.seat_no
ORDER BY 1 DESC, 2 ASC;