How about

SELECT TOP 1 A AS FirstMissingNumber

FROM (SELECT ROW_NUMBER() OVER (ORDER BY CoordinatorID) AS A, CoordinatorID

FROM Coordinators) T

WHERE A < CoordinatorID