Get last inserted row (LAST RECORD)

Question

how i write stored procedure to get last record of the table
It is ok if it is the primery key of the table