Isn’t Edinburgh higher ranking than Bristol? I mean I’d go with Edinburgh for the opportunities. Yes the downside of it being further away from family and friends (made before uni) is going to be tough but here’s the thing, once you finish uni and get a job, sometimes your work will give you opportunities that will definitely take you further away from your friends and family.
I have a friend whose work relocated her to America she had to choose between going or stay in uk but she won’t be considered for that kind of opportunity again, with that company etc but not only that she had the opportunity to travel and the company was paying. If she stayed she wouldn’t have that opportunity and if she stayed for friends and family she might regret not going, later in life because if she went later in life she would prob had to pay for everything herself vs her company covering it all. She chose to go because of that and it was an opportunity to travel, saving her money that she’d have spent if she traveled with her money etc.
So my point is. Listen if they are your real friends, they’d be there for you no matter where in the world you are. Same as your family. Would you rather be in Bristol closer to friends/family but the opportunities for you there doesn’t give you the “same pull” (if that makes sense) as Edinburgh? If you prefer the opportunities Edinburgh has for you/the course you want to study, then the cons on the Edinburgh should just be something you should think of “yes it would be harder to see them often but this would be a once in a lifetime opportunity and if they are true friends they’d keep in contact no matter what