MySQL 8.0

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

create table t(id int UNIQUE,v varchar(10));
insert into t (id,v)
values (2,'c'),(3,'a'), (5,'b');

Records: 3  Duplicates: 0  Warnings: 0


select * from t


id
v


2
c

3
a

5
b


CREATE PROCEDURE procedure_name(IN _a BIGint , IN _b BIGint)
BEGIN
   CREATE TEMPORARY TABLE T1 SELECT _b,v  FROM t WHERE id = _a;
   DELETE FROM t WHERE id = _a;
   UPDATE t SET id = _a WHERE id = _b;
   INSERT INTO t SELECT * FROM T1;
END 
CALL procedure_name(3,5)
select * from t


id
v


2
c

3
b

5
a