使用PHP代码在删除后自动重置id序列以在mysql表中排序

Question

Hello I want to run two queries in this code. The first delets a row in the mysql table and the second reorders the id value to the right sequence.

if(isset($_POST["image_id"]))
{   
    $file_path = 'files/' . $_POST["image_name"];
    if(unlink($file_path))
    {
        $count= 0;
        $count++;
        $query1 = "DELETE FROM tbl_image WHERE image_id = '".$_POST["image_id"]."'";
        $query2 = "UPDATE 'tbl_image' SET 'image_id' = '$count' " ;
        $statement = $connect->prepare($query1, $query2);
        $statement->execute();
    }
}