Hello and thanks for using Just Answer.
My name is ***** ***** am happy to assist you with your enquiry.
As John was not alive when the last surviving parent died, the legacy to him fails and does not pass in accordance with the terms of John's Will.
Therefore, unless the last surviving parent's Will directs that John's share should pass to a specified third party in the event of John dying beforehand, his share will pass to his sister.
I hope this assists and sets out the legal position.
If I have helped, I would be grateful if you could rate my answer.