MySQL 8.0

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

CREATE TABLE demo (
    id INT AUTO_INCREMENT,
    user_id VARCHAR(50) NOT NULL,
    port1 int,
    port2 int,
    port3 int,
    port4 int,
    PRIMARY KEY (id)
);
insert into demo(user_id,port1,port2,port3,port4)
values('Test1',10,20,30,40),
('Test2',100,200,300,400)
select * from demo


id
user_id
port1
port2
port3
port4


1
Test1
10
20
30
40

2
Test2
100
200
300
400


insert into demo(user_id,port1,port2,port3,port4)
select 'Test4',port1+1,port2+1,port3+1,port4+1
  from demo
 where user_id != 'Test4'
   and not exists (select 1 from demo where user_id = 'Test4')
order by id desc
limit 1
select * from demo


id
user_id
port1
port2
port3
port4


1
Test1
10
20
30
40

2
Test2
100
200
300
400

3
Test4
101
201
301
401