Scotland’s National newspaper to continue publishing ‘indefinitely’ after week-long pilot run exceeds expectations