By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tab1( id int, `other_id` int, limits int);
INSERT INTO tab1 VALUES
(1, 1, 4),
(2, 1, 5),
(3, 2, 3),
(4, 2, 2)
SELECT GROUP_CONCAT(id)
FROM
(SELECT t.id, t.other_id
, (SELECT SUM(limits) FROM tab1 WHERE limits > t.limits OR (id < t.id AND limits = t.limits)
OR (id = t.id)) required
FROM tab1 t
HAVING required <= '12'
ORDER BY id,other_id ASC) t1
| GROUP_CONCAT(id) |
|---|
| 1,2,3 |