Yes, two weeks in October would make perfect sense in Scotland. Otherwise the Autumn term is massive! But you have your summer Bank Holiday at the start of August, I think, so if you go back to school Mid-august, you don't lose the benefit of a day you don't have to take leave to go on holiday? Now our school is due back on Thursday 29th August, a late week away using Monday 26th's Bank Holiday isn't an option (unless you send them back late).
Personally, I wouldn't mind following the Scottish terms, and having the kids finish earlier in July. Recently, the weather tends to be better then anyway.
Otherwise, go the other way and extend the summer break into September, which is often lovely. Then no reason for a long break in October, and the summer term would be longer so the terms are more even. Noone's listening to me though, sadly.