BCA Scope

Yes it's a good option.
But don't go for MBA just because you are not good in Maths, Maths is in both MCA & MBA.
Go for MCA if interested in Programming/IT field.
Or MBA if interested in Management.
Make sure you do MCA from good college / university.
If you choose MCA then side by side of MCA do some certifications when you will be in 2nd or 3rd year as it will help you in getting good package.
Maths is hard I know but keep learning, give your best and someday you will love this subject.
Good luck.

India is one of the largest industries for information technology. I would say there are lots of opportunities in India after finishing your BCA.
Some of the IT roles you can start with-
Technical/Desktop Support Engineer
System / Network Engineer
Software Engineer/ Developer (WebApp/ Mobile)
Level 1 (HelpDesk) Engineer
Only BCA is not a good option to progress in career.
For a successful career you need to do Masters after BCA.
You can also do other short courses like software testing, web development, etc.
Just BCA or MCA are not enough unless you have extra skills.

MBA in IT specialization is not good. But not every MBA college has this specialization.
https://www.shiksha.com/mba/colleges/mba-colleges-india?uaf[]=specialization&ts=8351843&rf=filters&sp[]=283&ed[]=et_20
Please click on the above link to get a list of good MBA colleges with IT specialization. Choose the best college for you by comparing them with:
https://www.shiksha.com/resources/college-comparison

M.Sc will be better for you. It will not only save your year but also equip you for lectureship jobs in any colleges. Completing Masters early means 1 more year to try for government jobs as per age bar and you can complete your MCA if you want to do so even after M.Sc, through distance learning directly in 3rd year. So you will have 2 Masters instead of 1, if you do M.Sc first.

Hi Rohan, please mention your stream without which relevant options cannot be provided.

For graduates, job opportunities exist in government as well well as private sector. Also, self-employment options are available. After BCA, which is an Undergraduate course, graduates may take up government jobs that require a graduation degree (for example- Armed Forces, nationalised banks, PSUs etc).
When it comes to the private sector, software MNCs are the prime recruiters. Web hosting, IT sector, Electronics Industry are some other sectors that recruit BCA graduates.

Go for MCA. Master's degree provides more job opportunities.

MBA is the best one. Already you have technical knowledge of IT. So, instead of doing MCA if you do MBA it will add more to your career. MBA is all about business and how to look after a business. Almost all IT firms nowadays are looking for technical + Management knowledge. So, it is better pursue MBA Instead of MCA or LLB.