MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table lecturers (
emp_id INT UNIQUE PRIMARY KEY,
first_name VARCHAR(20),
last_name VARCHAR(20),
faculty VARCHAR(3)
)
CREATE PROCEDURE new_lect (IN emp_id INT, first_name VARCHAR(20), last_name VARCHAR(20), faculty VARCHAR(3))
BEGIN
INSERT INTO lecturers (emp_id, first_name, last_name, faculty) 
    VALUES (emp_id, first_name, last_name, faculty);
PREPARE stmt FROM 'SELECT * FROM lecturers ORDER BY emp_id DESC LIMIT 3;';
EXECUTE stmt;
DROP PREPARE stmt;
END
call new_lect (101, 'a', 'b', 'c');
call new_lect (102, 'a', 'b', 'c');
call new_lect (103, 'a', 'b', 'c');
call new_lect (104, 'a', 'b', 'c');


emp_id
first_name
last_name
faculty


101
a
b
c




emp_id
first_name
last_name
faculty


102
a
b
c

101
a
b
c




emp_id
first_name
last_name
faculty


103
a
b
c

102
a
b
c

101
a
b
c




emp_id
first_name
last_name
faculty


104
a
b
c

103
a
b
c

102
a
b
c


SELECT * FROM lecturers
        ORDER BY emp_id DESC 
        LIMIT 3;


emp_id
first_name
last_name
faculty


104
a
b
c

103
a
b
c

102
a
b
c