MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.13


create table existing (id  int unsigned not null)
insert into existing values (160886),(161000),(169197)
    SELECT a.id+1 AS 'Missing From', MIN(b.id)-1 AS 'Through'
    FROM existing AS a
    JOIN existing AS b ON a.id < b.id
    GROUP BY a.id
    HAVING a.id+1 < MIN(b.id)


Missing From
Through


160887
160999

161001
169196