Is it better for the guy to be on top the first time i have sex?

me and my bf have been dating for over 7 months and we have talked about sex. he wants to and i do too but i am afraid that it will hurt, i have done horseback ridding and sports but will it still hurt and is it better for him to be on top the first time? help what do you think?