`CREATE TEMPORARY TABLE test (id varchar(50), name varchar(50));
INSERT INTO test (id, name) VALUES (1, 'LF/2019/0001');
SELECT name FROM test;
UPDATE test SET name = (SELECT name FROM test ORDER BY id DESC) + 1 WHERE id = 1;`

Error show :

MySQL said: Documentation

#1137 - Can't reopen table: 'test'