MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


8.0.25


CREATE TABLE student (id int, name varchar(128));
INSERT INTO student (id,name) VALUES
(1,'Aurimas'),
(2,'Darius'),
(3,'Eligijus'),
(4,'Giedrius'),
(5,'Justinas');

select * from student;


id
name


1
Aurimas

2
Darius

3
Eligijus

4
Giedrius

5
Justinas


-- Sandbox
set @maxId = (select max(id) from student);
select @maxId;
select
  (id+1) DIV 2,
  id,
  if (
    @maxId = id and mod(id, 2) != 0,
    id, 
    if (
      mod((id+1), 2) = 0,
      id+1,
      id-1
    )
  )as newId,
  name
from student
order by newId;


@maxId


5




(id+1) DIV 2
id
newId
name


1
2
1
Darius

1
1
2
Aurimas

2
4
3
Giedrius

2
3
4
Eligijus

3
5
5
Justinas


-- Solution
set @maxId = (select max(id) from student);
select
  if (
    @maxId = id and mod(id, 2) != 0,
    id, 
    if (
      mod((id+1), 2) = 0,
      id+1,
      id-1
    )
  ) as id,
  name
from student
order by id;


id
name


1
Darius

2
Aurimas

3
Giedrius

4
Eligijus

5
Justinas