A body has been found in the search for a missing Scottish man who disappeared while on a stag do in Portugal.