WITH
aaa AS (
select 
  lag(LINE_ID, 1) over (order by LINE_ID) as LINE_ID_lag --前の結果を取得
 ,lead(LINE_ID, 1) over (order by LINE_ID) as LINE_ID_lead --前の結果を取得
 ,lag(SEAT_NO, 1) over (order by LINE_ID) as SEAT_NO_lag --前の結果を取得
 ,lead(SEAT_NO, 1) over (order by LINE_ID) as SEAT_NO_lead --前の結果を取得
 ,lag(RSV_STATUS, 1) over (order by LINE_ID) as lagpace --前の結果を取得
 ,lead(RSV_STATUS, 1) over (order by LINE_ID) as leadpace --後の結果を取得
FROM
 SEAT_RESERVE
)

SELECT
  LINE_ID_lag AS LINE
 ,SEAT_NO_lag AS SEAT_F
 ,SEAT_NO_lead AS SEAT_T
FROM aaa
WHERE
 lagpace = '0' AND leadpace = '0'
ORDER BY
 LINE_ID_lag DESC
 ,SEAT_NO_lag