That's difficult - it's easy to display just the rows that begin with F:
SELECT * FROM MyTable WHERE MyColumn LIKE 'F%'
But ordering is more complex, because SQL doesn't have particularly good string handling facilities.
You can do it, but it's a cludge:
SELECT * From MyTable
ORDER BY CASE WHEN SUBSTRING(MyColumn , 1 , 1) = 'F' THEN 1 ELSE 2 END, MyColumn