Can't speak for V8's, but a well looked after TD5 should be good for 250,000 miles. Service history quite important here.
Mine has 154,000 (bought a year ago at 147,000) and I hope to still have it in 10 years time. It gets used every day.
Whatever you get, service it regularly and use good...