ID                         NAME
6C3B11AE-A8C5-4D89-AECE-1DD6D9812E8D	101
8FCE12F6-7A3D-43DD-8950-93EEEF19AB3C	102
3758C5B0-E932-48D8-A7CE-300A801168FD	103
6EF220F4-4B26-40E9-8416-661ACB9DD218	104
A32929A5-BEA4-4CC7-B958-E65E58DFF498	105

...
FROM TAB t1    
LEFT JOIN TAB t2 ON t2.NAME = t1.NAME -1
LEFT JOIN TAB t3 ON t3.NAME = t1.NAME +1

from TAB t1    
LEFT JOIN TAB t2 ON t1.NAME = t2.NAME -1
LEFT JOIN TAB t3 ON t1.NAME = t3.NAME +1

DECLARE @Table table (id uniqueidentifier, name int);
DECLARE @i tinyint = 0

WHILE @i < 10
BEGIN
	INSERT @Table (id, NAME)
	VALUES (NEWID(), @i)

	SET @i += 1
END

SELECT * FROM @Table

DECLARE @Id uniqueidentifier
SELECT @Id = id FROM @Table WHERE name = 4

SELECT @Id

SELECT id, name FROM
	(SELECT TOP(1) id, name FROM @Table AS T1 
		WHERE name < (SELECT name FROM @Table WHERE id = @Id)
	ORDER BY name DESC) AS T
UNION ALL
SELECT id, name FROM
	(SELECT TOP(1) id, name FROM @Table AS T2 
		WHERE name > (SELECT name FROM @Table WHERE id = @Id)
	ORDER BY name ASC) AS T

select 
   case 
     when t2.id is not null
         then 'true' 
     else 'false' 
  end
from table t1
  left outer join table t2 on t1.name = t2.name +1

MIN()