The electric vehicle maker will roll out about 10 self-driving cars in some parts of the city, and scale up to about a thousand within a few months, Musk told CNBC in an interview.