How to Create Stored Procedure search to last id

Question

Hi Guys

I have a table contains to three field any one is PK

(TeamNo.)

(BankName)

(City)

(Id) is Identity 

 

i want to create stored procedures in order to serach by three fields  are above and at the same time i select to last record into insert a table according to three fielad(  

TeamNo.)

(BankName)

(City)           for last id inserted for any teams in a certain Bank and City .Please see table below :

 

 

Thanks