Update id with a random unique number between 1 & n

I have a table named listings. In it, there are n rows.
I need the ‘id’ for each row to randomly update with a unique number between 1 & n.

I have n ($count) as follows, but not sure what to do next.

$sql = "SELECT COUNT(*) FROM listings";
$result = mysqli_query($conn, $sql);
$count = mysqli_fetch_assoc($result)['COUNT(*)'];
Sponsor our Newsletter | Privacy Policy | Terms of Service