An island in Scotland 'teeming with life' has been named the best place in the whole of the UK for spotting the rare humpback whale.