No, this is not appropriate. If someone no longer wishes to keep their unanswered question on the site, they can delete it. If someone wishes to ask a new question, they can do so as a new question.
The only reasons I can see for not behaving straightforwardly are (i) some idea that it's more ecological to reuse question IDs; (ii) some attempt to circumvent restrictions on how many questions you delete or create. I have serious reservations about (i), and in particular I suspect that the extra hassle caused by the confusion would use more electricity and disk space than doing things the simple way; and if (ii) is the case then it should prompt people to take more care when posing questions, not to try to circumvent restrictions.