Does Aerospace Engineering have a good future scope?
Definitely! These days apart from the many governmental organizations, many private companies are also gearing up to take part in the space age like Blue Origin, SpaceX etc. And whenever private sector shows interest in something, it shoot exponentially. Moreover, many new space companies are going to operate in India according to the Government, so your future will be quite secure. Some of the top colleges from where you can do Aerospace Engineering are:
Indian Institute of Technology, Kanpur
Indian Institute of Technology, Kharagpur
Manipal Institute of Technology
Kumaraguru College of Technology
and many more. All the best!