кому интересно вот пральный ответ

SELECT LAST_INSERT_ID(id) AS `lid` FROM `news` WHERE 1 ORDER BY `lid` DESC LIMIT 1