Just read this whole thread with interest. The data is quite stark.
I have a late August DS still at primary who is achieving very well academically, which in turn positively affects his confidence, self-image, and aspirations.
Emotionally and socially, KS1 and especially YR were very tough, but things have improved lately (now going into Y5). He seems rather mature for his age, which might have to do with him being surrounded by older children (but never having been given the role of class baby/class clown) and being able to learn from that. Also expectations for behaviour have always been tailored to older children, and he has been lucky enough to have been able to rise to those expectations.
I suspect though that the differences might become more tangible again as puberty approaches, and the children's brains go through new developmental stages.
I would speculate that the main reason for the massive differences at KS1 are developmental differences at starting school, where the 1 year difference is a whole quarter of the 4yo's life, along with YR being 'designed' for 5yos and Y1 for 6yos, and KS1 SATS measuring expected learning outcomes at age 7 despite 1/6 of the children who take them not being 7 yet.
I would then speculate that the largest part of the persisting differences up to GCSE level are a direct effect of a) the children's early experiences of school, and b) their early attainment.
b: With all the ways teacher expectations influence their teaching, and the targets set based on earlier attainments, statistically a child's KS1 attainment can become 'prophetic'.
a: A child who has internalised the view that they are 'not as clever' as their 'peers' or just find that school doesn't suit them, might be affected by this for life.
Both a and b would hold for social and emotional aptitude, and behaviour, as well.
With regards to sports, DS is very sporty but only very recently has begun to be acknowledged for this (causing some upset as his achievements caused some autumn born boys who were accustomed to having places in teams to suddenly lose out). Again, I believe this to be a temporary reprieve from age about 8.5 (his peers all being 9+) until statistically his peers start getting their puberty testosterone boosts and him having to wait another year or so - he won't be catching that one up anymore.
I know this doesn't count as sports in England, but DS plays chess competitively and again there appear to be strong effects. If he had been born a couple of weeks later, he'd be being 'noticed' right now, which would be opening up opportunities (such as coaching and training). But there are also advantages. Many competitions go by school year group and him being young in his year rather than old in the year below means that he gets to play against stronger opponents and therefore gain valuable experience; also the very young age groups obviously see many as yet ungraded and low graded children, so it is harder to achieve a high grade oneself (grades are determined by one's opponents' grades and one's results against them). The grades are used for international selections, and international youth competitions go by calendar year not school year, so Autumn borns are doubly disadvantaged - they are the youngest hoping to be selected, but 'at home' they usually compete against even younger and on average low or ungraded opponents, making it really hard to achieve the necessary grades (whilst being much more likely to bring home trophies and confidence boosts from any one particular local competition that goes by school year).