The night was so hot that no one could sleep. => So hot was the night that no one could sleep.

Then, is it possible to convert
He is such a good lecturer that his classes are always full.

Such a good lecturer is he that his classes are always full.

I don't think "So hot was the night" is a correct structure of the sentence.
Therefore, "such a good lecturer is he" isn't one either.

Chek this out, vince.

This is a common inversion, usually used with an adjective & the verb `be`.
e.g. So exciting was the soap opera, that I forgot to do my English homework.

Teachers: We supply a list of EFL job vacancies
Taka -- it's possible, but it does not sound like ordinary conversation. You might hear something like that in a poem, or in a speech, where language is rearranged a little to produce a dramatic effect. It rather reminds me of an old nursery rhyme (a child's poem from long ago) which ends, "What a good boy am I!"
Yes; or in a context where you want to make a strong connection with the end of the preceding sentence, for emphasis.

From a random google:

"No society with any semblance of modern government would tolerate such outrageous behavior by the authorities in the case of, say, stolen pianos; but the copyright industry wants us to believe that its intellectual property is in a category by itself.

Indeed, so rare and precious are the fruits of its [i.e. the copyright industry's] labor that it, unique among the world's enterprises, deserves to have the rules of decent civil behavior suspended."

Here, for instance, the inversion permits a particular sarcastic emphasis on 'so rare and precious'. (Though I think the speaker's rhetoric fails him in the last clause.)

khoff and MrP.
"What a good boy am I!"

the inversion permits a particular sarcastic emphasis on 'so rare and precious'.

Thank you. But I'm asking specifically about ' Such a good lecturer is he that...' Are you saying that this is also possible?
Students: We have free audio pronunciation exercises.
Many things are grammatically possible, Taka, but that doesn't mean they are in common use. Yes, it is certainly grammatically possible.
Hello Taka

The 'such' inversion certainly seems rarer than the 'so' inversion; I'm hard pressed to think of an example.

As JTT says, your 'lecturer' inversion is grammatical; but it gives the impression of a highly mannered prose style. I would expect to find similar structures in the writings of Carlyle, for instance; or perhaps Henry James.

I understand. Thank you, people!
Site Hint: Check out our list of pronunciation videos.