Add ORDER BY idx DESC
ORDER BY idx DESC
UPDATE my_table SET idx = idx + 1 WHERE user_name = 'Bob' ORDER BY idx DESC;
See example