Single SQL query to retrieve data in a particular order (not ASC/DESC)
You can simply do

SELECT * FROM reviews 
WHERE product_id = 723 
ORDER BY language_id = 4 DESC, language_id ASC;


language_id = 4 returns true or false, 1 or 0. Sort descending and you have language_id = 4 first, then all others.