Gareth Bale says leading Wales out in a major tournament is going to be one of the highlights of his career.