How was Arch-Curate Vyrthur able to create the "Tyranny of the Sun prophecy" and have it placed in three Elder Scrolls?

Also, what does Auri-El have to do with the sun if it was a hole to Aetherius created by Magnus? Does it have to do with him ascending?

Aetherius is where the gods reside, and Auriel is basically their leader/king.

He didn't place anything into the Elder Scrolls. The Elder Scrolls said "don't let this come to pass".

Basically Vyrthur decided that he would get revenge for Auri-El forsaking him so he came up with the 'prophecy' in order to lure a daughter of coldharbor into his grasp to taint Auri-El's bow because he is unable to exact revenge on Auri-El himself.

And the elder scrolls role in this? Basically what MadCat221 said.

To clarify, the Elder Scrolls mention events that may happen (not necessarily will; they aren't prophetic in that way, regardless of what TESO's MQ wants you to think). Vyrthur created a prophecy by getting the right people to believe something would happen. This is turn made it something that may happen (a self-fulfilling prophecy, kind of), so the Elder Scrolls would speak of it.

Possibilities become un-reality only after their condition failed, and anything that does not belong to un-reality is in the Elder Scrolls, as its stream of cause-result is not yet to be broken.

The Elder Scrolls could speak of what is yet to happen, but could not speak of what should not have happened. The prophecy of Vyrthur belongs to the former catalog, thus mentioned in the Elder Scrolls.