Footnotes are inserted at the bottom of the column where the footnote is located.
That is, if your footnote number is in the First Column then the footnote appears in the first column.
If your footnote is in the Second Column - then it will appear at the foot of that column.
There are no other options directly in InDesign.
Try these scripts