First you should have a column in Tables named as (Last_Updated or Recent_Visit) in datetime datatype.
That column should fill with datetime of the current timing Eg - Getdate()
Dont convert the datetime of getdate(), because you cant get latest one.
Query Below:
Select top 25 * from MyDB..MyTable with (Nolock) order by Recent_Visit desc