Select rows where smaller row does not exist
Oracle supports LAG so you should be able to do something like.

SELECT T.ID, 
       T.NAME
FROM
(
SELECT ID, 
       NAME,
       LAG(ID) OVER (ORDER BY ID) AS PREVID
FROM YourTable
) T
WHERE ID &gt; PREVID + 1;


To compare the Id with the previous one and only return ones with a gap greater than 1.

(Untested as SQL Fiddle is currently returning errors when I try and create an Oracle Fiddle)