[Solved] Custom order in SQL Procedure

try this:

SELECT ..., CASE WHEN LFLT.ID = 3 THEN 0 ELSE LFLT.ID END AS OrderIndex
FROM ...
ORDER BY OrderIndex