Choosing between a masters at a top tier university, and a PhD at a lower tier university
On balance, I'd say go to Cambridge. If you do good research and write a high quality MPhil thesis, it is very unlikely that you will not get an opportunity to stay on for a PhD.