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 |