MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE clients (
    id_client INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
    surname TEXT,
    name TEXT,
    patronimic TEXT,
    phone_number TEXT
)
INSERT INTO clients (
    surname,
    name,
    patronimic,
    phone_number
) VALUES (
    'Bidlocoder',
    'Vasyan',
    'Makakinovich',
    '88005553535'
)
SELECT LAST_INSERT_ID()


LAST_INSERT_ID()


1


SELECT id_client FROM clients WHERE phone_number = '88005553535'


id_client


1