使用单个查询在更新时自动增加mysql列字段

suppose I have this code

假设我有这个代码

$ids = execute_query("SELECT id FROM table WHERE field = 'value' ORDER BY order_field");
$query = "UPDATE table SET increment = CASE";
for($i = 0; $i <= sizeof($ids); $i++){
  $query .= " WHEN id = " . $ids[$i] . " THEN " . $i;
}
$query .= " END WHERE field = 'value'";
$ids = ex