Applied 7.4V between GND and RST pin.

I connected everything as usual i.e Promini, FTDI USB adaptor and connected to my laptop. I then tried burning bootloader from the Arduino IDE but failed.

You can not burn a boot loader like this.

Do Burning Bootloader requires one to connect to SCK, MOSI, MISO pins of arduino

Yes see:-