MySQL 8.0

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

DROP TABLE IF EXISTS student;
CREATE TABLE student (ano INT, name VARCHAR(255), gender VARCHAR(1), age INT, place VARCHAR(255));
INSERT INTO student (ano, name, gender, age, place) VALUES (114, 'ron', 'm', 18, 'cbe');
INSERT INTO student (ano, name, gender, age, place) VALUES (115, 'dhruv', 'm', 18, 'cbe');
INSERT INTO student (ano, name, gender, age, place) VALUES (116, 'mini', 'f', 23, 'chennai');
INSERT INTO student (ano, name, gender, age, place) VALUES (117, 'anothertest', 'f', 21, 'chennai');
INSERT INTO student (ano, name, gender, age, place) VALUES (118, 'anothertest', 'f', 22, 'chennai');
INSERT INTO student (ano, name, gender, age, place) VALUES (119, 'yash', 'm', 20, 'chennai');
INSERT INTO student (ano, name, gender, age, place) VALUES (120, 'aathmika', 'f', 19, 'delhi');
INSERT INTO student (ano, name, gender, age, place) VALUES (121, 'aadhi', 'm', 9, 'pune');

SELECT *
    FROM student s1
    WHERE age > 18
          AND NOT EXISTS
          (SELECT * FROM student s2
           WHERE s2.ano < s1.ano  /* Or could alternatively use > here */
             AND s2.age > 18
             AND s2.place = s1.place);
         
    SELECT *
    FROM student s1
    WHERE age > 18
          AND NOT EXISTS
          (SELECT * FROM student s2
           WHERE s2.ano > s1.ano  /* Alternative version */
             AND s2.age > 18
             AND s2.place = s1.place);

ano	name	gender	age	place
116	mini	f	23	chennai
120	aathmika	f	19	delhi

ano	name	gender	age	place
119	yash	m	20	chennai
120	aathmika	f	19	delhi