I've been stumped on this and tried everything I can think of but I can't get Laravel to execute a working mysql query to reorder an ordering column when deleting a row.

Here's a sample simplified query, which works directly in mysql: