MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE student (
id int,
 name varchar(128)
);

INSERT INTO student (id,name) VALUES
(1,'John'),
(2,'Bob'),
(3,'Alice'),
(4,'Don'),
(5,'Eve');
UPDATE student s1
JOIN student s2 ON s1.id = IF(s1.id % 2 = 0,s2.id + 1,s2.id - 1)
SET s1.name = s2.name
SELECT * FROM student


id
name


1
Bob

2
John

3
Don

4
Alice

5
Eve