Not a football stadium, but as the topic is about Scottish stadiums...
Scotstoun Stadium, Home of the Glasgow Warriors. Currently capped at 7351, but Glasgow have sold out every game played there since March 2017. Believe SRU may be thinking about talking to Glasgow Life (Who own the Stadium) into redeveloping the North stand to bring it in line with the Main stand to increase overall capacity to 10,000.