with tmp  as (

select  a.line_id , a.seat_no , a.rsv_status , b.line_id  as b_id , b.seat_no  as b_no, b.rsv_status as b_st

from 
    seat_reserve  as a  left join seat_reserve as b 
    on a.line_id = b.line_id  and b.seat_no = a.seat_no + 1  
where
    a.rsv_status = 0 
    and b.rsv_status = 0
)



select  t1.line_id as LINE , t1.seat_no as SEAT_F , t2.b_no as SEAT_T

from tmp as t1  inner join tmp as t2
on t1.b_no = t2.seat_no  and t1.line_id = t2.line_id

order by    
    1 desc,
    2 asc