Getting a Variable From a Database via an SQL Command

Here is my code:

$result1 = mysqli_query($con, "INSERT INTO third (id2, language, divid, point, ce, datetime, IP) VALUES ('$id2', '$language', '$new_divid', 0, 'b', NOW(), '$ipaddress')"); 

In this code (MySQL) I add a new line to the database and I didn't add a id1 column to it, cause id1 is auto-increment in the table - it adds id1 automatically.

Now what I am trying is tp get id1 back, inside the same SQL command BUT I don't want use PHP again and again. Is this possible?

Note: I saw something like OUTPUT INSERTED.id1 but I didn't understand what it is and whether i can use it. (I saw it in this question)