If I get the Sims 3 expansion pack (Late Night) first, will I also be able to get Ambitions/World Adventures?

It doesn't matter. You can install whatever expansions packs in whatever order you like, but when you fire up always use the disk of the most recently released expansion pack you have installed.