optical fibres are best choice, if you have bsnl there then it should be good. but as people saying, ping is important, check the ping value with the server u r gonna play (some servers in south east asia has good ping since our submarine fiber cables go through those places first).
well, with weird connection too, you can play mp even if you get high ping values like 350ms, some servers wont allow this much lag, but some does allow, and the playing experience will not be very good (it will be marginally ok - smoothly playable, but you will loose in many high speed actions). however, if you see packet looses/timeouts, then that's of course very bad connection for gaming.
well, if you are not playing fps but playing strategy or mmo, then high ping values like 500ms may seem ok.
wireless is 100% bad for gaming, unless you are playing board games like chess or cards. you need to be very close to the tower to get good ping with the base, and forget it if its far away.