select(case when mod(id,2)!=0 AND counts != id then id+1when mod(id,2)!=0 AND counts = id then idelse id -1end) as id,student
fromseat,(selectcount(*) as countsfrom seat) as seat_counts
order by id asc;