SpaceX founder Elon Musk said he gave the company "less than a 10% chance of succeeding at all" when it first started, and it is now going public "with the largest IPO ever".