Prince Harry clarified that he will remain sixth in the line of succession to the throne going forward