PHP - Se puede obtener un ID tras un Insert?

$sql = "INSERT INTO Usuarios (Nickname, ProvinciaOrigen) VALUES ('".$Nickname."','".$ProvinciaOrigen."')";

$result = mysqli_query($conn, $sql);

$sql = "SELECT ID FROM Usuarios WHERE ProvinciaOrigen='$ProvinciaOrigen' LIMIT 1";

$result = mysqli_query($conn, $sql);

if(mysqli_num_rows($result) > 0){

    while($row = mysqli_fetch_assoc($result)){

        echo $row['ID'];

    }

}

// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($conn->connect_error) {

    die("Connection failed: " . $conn->connect_error);

}

$sql = "INSERT INTO MyGuests (firstname, lastname, email)

VALUES ('John', 'Doe', 'john@example.com')";

if ($conn->query($sql) === TRUE) {

    $last_id = $conn->insert_id;

    echo "New record created successfully. Last inserted ID is: " . $last_id;

} else {

    echo "Error: " . $sql . "<br>" . $conn->error;

}

$conn->close();

$sql = "INSERT INTO MyGuests (firstname, lastname, email)

VALUES ('John', 'Doe', 'john@example.com')";

$result = $conn->query($sql);

$conn->insert_id