MySQL 8.0

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

CREATE TABLE test(id INTEGER PRIMARY KEY, a INTEGER, b INTEGER);
INSERT INTO test VALUES(1,6,5);
INSERT INTO test VALUES(2,3,2);
INSERT INTO test VALUES(3,5,1);
--INSERT INTO test VALUES(4,5,5);
--INSERT INTO test VALUES(5,9,8);
--INSERT INTO test VALUES(6,1,7);

select *
from test
select * from test


id
a
b


1
6
5

2
3
2

3
5
1


SELECT t.ID
FROM test t CROSS JOIN
     (SELECT MIN(id) as min_id
      FROM test
      WHERE A <= B
     ) tt
WHERE t.id < tt.min_id OR tt.min_id IS NULL


ID


1

2

3