Here is a sample approach
CREATE TABLE #SampleTable
(
ID INT,
[Name] VARCHAR(50)
)
INSERT INTO #SampleTable
SELECT 1, 'A' UNION ALL
SELECT 2, 'B' UNION ALL
SELECT 3, 'C' UNION ALL
SELECT 4, 'X'
SELECT [Name] FROM
(
SELECT CASE WHEN ID = 4 THEN 0 ELSE 1 END AS SortOrder, ID, [Name] FROM #SampleTable
) T
ORDER BY SortOrder, [Name]
DROP TABLE #SampleTable