Untold story of Royal Scots’ final stand at Le Paradis is revealed