Et comme ça ?

DELETE
FROM matable AS t1
WHERE EXISTS
( SELECT NULL
FROM matable AS t2
WHERE t2.id1 = t1.id1
AND t2.id2 >...