Select *
 From yourTable
 Order By (Case When col=1 then 0 else 1 End), Col1

DROP TABLE #Temp
CREATE TABLE #Temp (regionId VARCHAR(10), ParentId VARCHAR(10), TextColumn VARCHAR(10))
INSERT INTO #Temp (regionId, ParentId, TextColumn)
SELECT 'a1', '1', 'wwer' UNION ALL
SELECT 'b1', '1', 'yrt' UNION ALL
SELECT 'c1', '1', 'ryrt' UNION ALL
SELECT 'a11', 'a1', 'eryrty' UNION ALL
SELECT 'b11', 'b1', ' nbnvnfth' UNION ALL
SELECT 'c11', 'c1', 'vc' UNION ALL
SELECT 'b111', 'b11', 'vbc' UNION ALL
SELECT 'a111', 'a11', 'cb' UNION ALL
SELECT 'c111', 'c11', 'bc'

SELECT RIGHT('000000000' + regionId, 10), * 
FROM #Temp 
ORDER BY RIGHT('000000000' + regionId, 10), ParentId

SELECT * 
FROM #Temp 
ORDER BY (CASE WHEN ParentID = '1' THEN 0 ELSE 1 END), ParentId