MySQL 如何快速查出缺失数据的主键 id

MySQL 如何快速查出缺失数据的主键 id

例如，有如下数据：
id 1，3，7，8，10

如何快速查出缺失的：
2，4，5，9

SELECT a.id+1 AS START, MIN(b.id) - 1 AS END
    FROM limit_up_predict AS a, limit_up_predict AS b
    WHERE a.id < b.id
    GROUP BY a.id
    HAVING START < MIN(b.id)