PHPでSQLiteのID欠番を寄せて連番に直す方法。

<?php
  $db = new SQLite3("[データベースファイル名]");
  $table = "[テーブル名]";
  $query = "SELECT * FROM $table";
  $result = $db->query($query);
  $new_id = 1;
  while ($row = $result->fetchArray()) {
    $id = $row["id"];
    if ($new_id !== $id){
      echo "$new_id : $id \n";
      $query= "UPDATE $table SET id = $new_id WHERE id = $id";
      $result1 = $db->query($query);
    }
    $new_id += 1;
  }