MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE task_1 (
    id INT UNSIGNED NOT NULL DEFAULT 0,
    name VARCHAR(255) NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE task_2 (
    id INT UNSIGNED NOT NULL DEFAULT 0,
    name VARCHAR(255) NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE sequence (
  id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL
);
CREATE TRIGGER task_1_before_insert
  BEFORE INSERT ON 
    task_1
  FOR EACH ROW
BEGIN
  INSERT INTO sequence SET id=DEFAULT;
  SET NEW.id = LAST_INSERT_ID();
  DELETE FROM sequence WHERE id < NEW.id;
END
CREATE TRIGGER task_2_before_insert
  BEFORE INSERT ON 
    task_2
  FOR EACH ROW
BEGIN
  INSERT INTO sequence SET id=DEFAULT;
  SET NEW.id = LAST_INSERT_ID();
  DELETE FROM sequence WHERE id < NEW.id;
END
INSERT INTO task_1 SET name = 'example 1';
INSERT INTO task_2 SET name = 'example 2';
SELECT * FROM task_1;
SELECT * FROM task_2;
SELECT * FROM sequence;


id
name


1
example 1




id
name


2
example 2




id


2