Find missing Id in SQL Server through CTE

Common table expression(CTE) basically used Specifies a temporary named result set, Create a recursive query and Reference the resulting table multiple times in the same statement.