A Scottish island beach featuring a mix of soft sand and rock has been crowned one of the best in the UK, with the experts describing it as "breathtakingly beautiful".