SELECT t1.id FROM (SELECT * FROM test WHERE s=0 ) t1 WHERE EXISTS
     (SELECT id
      FROM test t2
      WHERE t2.id IN (t1.id + 10, t1.id - 10))

SELECT t1.id FROM `test` AS t1 WHERE t1.s = 0 AND
    (SELECT t2.id FROM `test` AS t2 WHERE t2.id = t1.id + 10 AND t2.s = 0)

SELECT t1.id FROM `test` AS t1 WHERE t1.s = 0 AND
(SELECT t2.id FROM `test` AS t2 WHERE t2.id = t1.id + 1 AND t2.s = 0) AND
(SELECT t2.id FROM `test` AS t2 WHERE t2.id = t1.id + 10 AND t2.s = 0) AND
(SELECT t2.id FROM `test` AS t2 WHERE t2.id = t1.id + 11 AND t2.s = 0)