SQL Pro

SELECT 

CASE 

WHEN ((SELECT MAX(id) FROM seat)%2 = 1) AND id = (SELECT MAX(id) FROM seat) THEN id

WHEN id%2 = 1 THEN id + 1

ELSE id - 1

END AS id, student

FROM seat

ORDER BY id;