The number who are members of football clubs in Scotland has increased by more than 16,500 since 2017, according to figures seen exclusively by The Herald.