The author of the bill which made St Andrew’s Day a bank holiday is disappointed by how little the national day is observed