resequence construction.id

<?php

$serverIP = '127.0.0.1';
$serverUser = 'dbuser';
$serverPass = 'dbpass';
$serverDB = 'exile';
$ServerPort = '3306';


$sql = "SELECT * FROM construction ORDER BY ID";
$result = mysqli_query($db_local, $sql);
$new_id = 1;

while(row = mysqli_fetch_object($result))
{
    $id                 = $row->id;
    $last_updated_at    = $row->last_updated_at;
    $sql2 = "UPDATE construction SET id = '$new_id', last_updated_at = '$last_updated_at' WHERE id = '$id'";
    echo "<hr>$sql2<hr>";
    $result2 = mysqli_query($db_local, $sql2);
    $id = $id +1;
}
?>