Solution 1 三表联结

SELECT DISTINCT L1.num AS ConsecutiveNums
FROM Logs L1, Logs L2, Logs L3
WHERE
    L1.num=L2.num AND
    L2.num=L3.num AND
    L2.id-L1.id=1 AND
    L3.id-L2.id=1;