SELECT 1 + COUNT(1)
INTO @sort
FROM t_tree AS t
WHERE t.f_parent_id = 2
LIMIT 1;

UPDATE t_tree AS t
SET f_sort = (@sort := @sort - 1)
WHERE T.f_parent_id = 2
ORDER BY f_sort DESC;