What is the best suitable transaction fee to avoid high fees but still get confirmed? Which is the best suitable transaction or also called as the network fee that can be set in order to avoid high fees and yet get the confirmation of the transaction.

Can we say that 0.00000100 BTC is appropriate ?
First a clarification: Anyone giving a flat fee in response to this question is not giving sufficient information. Transactions are (generally) selected by fee rate. This means that besides the flat transaction fee that was included, the weight of your transaction plays a critical role:

fee rate [sats/vB] = transaction fee [satoshis] / weight of transaction [virtual bytes]


In order to get a confirmation, you need to successfully compete with the other waiting transactions for block inclusion. Depending on your time preference, you either have to place your transaction within the top 4,000,000 weight units of the block author's mempool sorted per transaction fee rate, or be willing to wait until blockspace demand cools down a bit to drop to the fee rate that you're willing to pay.

There are a number of services that attempt at predicting appropriate fee rates for various inclusion times, e.g.: 


bitcoinfees.github.io
whatthefee.io
bitcoinfees.earn.com
@corefeehelper (tweets Bitcoin Core fee estimates hourly)


There are also sites that give perspective on the mempool to facility users picking their own fee rates, e.g.:


jochen-hoenicke.de/queue/#24h
https://btc.com/stats/unconfirmed-tx


Finally, there is a general lower limit, the minRelayTxFee (which despite the name is a fee rate), for which the default currently is 1,000 satoshis per kvB, or 1 satoshi per virtual byte. Sending a transaction below a node's minRelayTxFee will cause the node to drop it from their mempool instead of relaying it, i.e. such a transaction will generally never get to the miners, and won't get mined into a block even when blocks aren't full.

Conclusion: If you have a low time-preference, e.g. in the case of creating consolidation transactions, and blocks haven't been consistently full, sending a transaction with a fee rate of 1 satoshi/vB will pay the lowest fees which will still get you confirmed.