CREATE TABLE sequence (
   name TEXT PRIMARY KEY,
   next_val INTEGER NOT NULL
);

CREATE TRIGGER update_sequence
BEFORE INSERT ON any_table
FOR EACH ROW
WHEN NEW.id IS NULL
BEGIN
   UPDATE sequence SET next_val = next_val + 1 WHERE name = 'table_name';
   UPDATE any_table SET id = (SELECT next_val FROM sequence WHERE name = 'table_name') WHERE rowid = NEW.rowid;
END;

CREATE TABLE users (
   id INTEGER PRIMARY KEY,
   name TEXT NOT NULL
);

INSERT INTO users (name) VALUES ('John');
INSERT INTO users (name) VALUES ('Jane');
INSERT INTO users (name) VALUES ('Alice');

SELECT * FROM users;

UPDATE sequence SET next_val = 100 WHERE name = 'table_name';

DELETE FROM sequence WHERE name = 'table_name';