Well, for simple operations:
SELECT * FROM bp
ORDER BY CASE WHEN value = 2 THEN 1
WHEN value = 1 THEN 2
ELSE value
END
But for bigger tables you are going to have to either decide on some rules instead of absolute values or add an "Ordering" column to your table. (I'd go for the extra column, myself)