MySQL 8.0

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

CREATE TABLE bookings(ID int AUTO_INCREMENT PRIMARY KEY,unique_id int, branch_id int, pos_user_id int, user_id int, user_address_id  int)
CREATE TABLE bookings_clone(ID int ,unique_id int, branch_id int, pos_user_id int, user_id int, user_address_id  int)
CREATE TRIGGER after_booking_inserted AFTER INSERT ON bookings
FOR EACH ROW BEGIN  
    INSERT INTO bookings_clone select * from bookings where id = NEW.id;
END;
INSERT INTO bookings  VALUES(NULL,13,13,13,13,13)
SELECT * FROM bookings_clone


ID
unique_id
branch_id
pos_user_id
user_id
user_address_id


1
13
13
13
13
13