Is it permissible to offer mandatory prayer while sitting?

All perfect praise be to Allah, The Lord of The Worlds, and may His Peace and Blessings be upon our Prophet Muhammad and upon all of his family and companions.                                                                                                                                                                                                                            Standing up is a pillar in the mandatory prayer and the prayer is not valid without it unless one cannot do it. As for Nafila (supererogatory prayer), one can perform it in the state of sitting even if he/she can stand, but his/her reward is half the reward of the person who prays while standing if he/sh has no legal excuse for such an act. And Allah Knows Best.

Is prayer mandatory on a dying person who goes through a state of unconsciousness, then wakes up?

If he wakes up and was conscious, then he should pray the way/manner he could, but if he wasn't, then he is exempted from obligatory prayer as Allah Says in this regard (What means): "On no soul doth God Place a burden greater than it can bear." [Al-Baqarah/286].

What is the Islamic ruling on parents asking son to divorce his wife?

Praise be to Allah the Lord of the Worlds.

If their asking him to do so is justified in Sharia, then there is no blame on him to obey them. And Allah The Almighty Knows Best.

I can`t afford to get married, what should I do to curb my sexual drives?

You should offer a lot of voluntary fasting, keep busy with useful and permissible acts and make supplication to Allah, The Exalted.