Sailors serving aboard a Royal Navy frigate which has been retired were left emotional by the end of the warship’s career.