MySQL 8.0

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

CREATE TABLE `new` (id int not null auto_increment, name varchar(20), primary key (id));
insert into `new` (name) VALUES ('test'), ('test2'), ('test3');

Records: 3  Duplicates: 0  Warnings: 0

SELECT * FROM `new`

id
name

1
test

2
test2

3
test3

SELECT * FROM `new` ORDER BY id DESC LIMIT 1

id
name

3
test3