Police in South Queensferry, Scotland, have confirmed they have found the body of the Frightened Rabbit singer who has been missing since the early hours of 9 May.