select case when id % 2 = 1 and id = records.count then id
            when id % 2 = 1 then id + 1
       else id - 1
       end as id,
       student
       from seat,
            (select count(*) as count from seat) as records
order by id;